Estimating Null Values in Relational Databases Using Analogical Proportions
نویسندگان
چکیده
This paper presents a novel approach to the prediction of null values in relational databases, based on the notion of analogical proportion. We show in particular how an algorithm initially proposed in a classification context can be adapted to this purpose. This work focuses on the case of a transactional database, where attributes are Boolean. The experimental results reported here, even though preliminary, are encouraging since the approach yields a better precision, on average, than the classical nearest neighbors technique.
منابع مشابه
Adaptive-clustering Based Method to Estimate Null Values in Relational Databases
Data preprocessing is an essential step of knowledge discovery. Data preprocessing comprises data cleaning, data integration, data transformation, data reduction and data discretization. Estimating null values is a task of data cleaning. Null values in a database are significant sources of poor data quality. Therefore, the appropriate handling of null values is an important task of data preproc...
متن کاملEstimating Null Values In Relational Database Systems Based On Genetic Algorithms
In this paper, we present a new method to estimate null values in relational database systems based on genetic algorithms. It can tune the membership functions of the linguistic values of the attributes in relational database systems for estimating null values. The proposed method can get a higher average estimated accuracy rate than the existing methods for estimating null values in relational...
متن کاملGenerating weighted fuzzy rules from relational database systems for estimating values using genetic algorithms
In recent years, some methods have been proposed to estimate null values in relational database systems. However, the estimated accuracy of the existing methods are not good enough. In this paper, we present a new method to generate weighted fuzzy rules from relational database systems for estimating null values using genetic algorithms (GAs), where the attributes appearing in the antecedent pa...
متن کاملOn the Logic of SQL Nulls
The logic of nulls in databases has been subject of investigation since their introduction in Codd’s Relational Model, which is the foundation of the SQL standard. In the logic based approaches to modelling relational databases proposed so far, nulls are considered as representing unknown values. Such existential semantics fails to capture the behaviour of the SQL standard. We show that, accord...
متن کاملThe Algebra and the Logic for SQL Nulls
The logic of nulls in databases has been subject of investigation since their introduction in Codd’s Relational Model, which is the foundation of the SQL standard. In the logic based approaches to modelling relational databases proposed so far, nulls are considered as representing unknown values. Such existential semantics fails to capture the behaviour of the SQL standard. We show that, accord...
متن کامل